EDLD 610 Winter 2020 Final Project
Jim Wright
2/3/2020
Plot 1
Data is ranked in order of median income with the highest incomes at the top of the data set
The purpose of these plots will be to display the distribution of median salaries by college major, by specifically focusing on both the top 20 median salaries and bottom 20 median salaries
## # A tibble: 6 x 21
## rank major_code major total men women major_category share_women
## <int> <int> <chr> <int> <int> <int> <chr> <dbl>
## 1 1 2419 PETR… 2339 2057 282 Engineering 0.121
## 2 2 2416 MINI… 756 679 77 Engineering 0.102
## 3 3 2415 META… 856 725 131 Engineering 0.153
## 4 4 2417 NAVA… 1258 1123 135 Engineering 0.107
## 5 5 2405 CHEM… 32260 21239 11021 Engineering 0.342
## 6 6 2418 NUCL… 2573 2200 373 Engineering 0.145
## # … with 13 more variables: sample_size <int>, employed <int>,
## # full_time <int>, part_time <int>, full_time_year_round <int>,
## # unemployed <int>, unemployment_rate <dbl>, median <int>, p25th <int>,
## # p75th <int>, college_jobs <int>, non_college_jobs <int>,
## # low_wage_jobs <int>## # A tibble: 6 x 9
## rank major_code major major_category total men women share_women
## <int> <int> <chr> <chr> <int> <int> <int> <dbl>
## 1 1 2419 PETR… Engineering 2339 2057 282 0.121
## 2 2 2416 MINI… Engineering 756 679 77 0.102
## 3 3 2415 META… Engineering 856 725 131 0.153
## 4 4 2417 NAVA… Engineering 1258 1123 135 0.107
## 5 5 2418 NUCL… Engineering 2573 2200 373 0.145
## 6 6 2405 CHEM… Engineering 32260 21239 11021 0.342
## # … with 1 more variable: median <int>## # A tibble: 173 x 4
## major median p25th p75th
## <chr> <int> <int> <int>
## 1 PETROLEUM ENGINEERING 110000 95000 125000
## 2 MINING AND MINERAL ENGINEERING 75000 55000 90000
## 3 METALLURGICAL ENGINEERING 73000 50000 105000
## 4 NAVAL ARCHITECTURE AND MARINE ENGINEERING 70000 43000 80000
## 5 CHEMICAL ENGINEERING 65000 50000 75000
## 6 NUCLEAR ENGINEERING 65000 50000 102000
## 7 ACTUARIAL SCIENCE 62000 53000 72000
## 8 ASTRONOMY AND ASTROPHYSICS 62000 31500 109000
## 9 MECHANICAL ENGINEERING 60000 48000 70000
## 10 ELECTRICAL ENGINEERING 60000 45000 72000
## # … with 163 more rows
Plot 2
The purpose of Plot 2 will be to communicate visualizations of the recent-grads data to display trends in unemployment rate per college major and major category
## # A tibble: 1 x 1
## `mean(median)`
## <dbl>
## 1 40151.## # A tibble: 1 x 1
## `mean(unemployment_rate_percentage)`
## <dbl>
## 1 0.0682
Plot 3
The purpose of plot 3 will be to use the recent_grads and women_stem data sets to compare trends in the percentage of women working in these fields
## # A tibble: 6 x 21
## rank major_code major total men women major_category share_women
## <int> <int> <chr> <int> <int> <int> <chr> <dbl>
## 1 1 2419 PETR… 2339 2057 282 Engineering 0.121
## 2 2 2416 MINI… 756 679 77 Engineering 0.102
## 3 3 2415 META… 856 725 131 Engineering 0.153
## 4 4 2417 NAVA… 1258 1123 135 Engineering 0.107
## 5 5 2405 CHEM… 32260 21239 11021 Engineering 0.342
## 6 6 2418 NUCL… 2573 2200 373 Engineering 0.145
## # … with 13 more variables: sample_size <int>, employed <int>,
## # full_time <int>, part_time <int>, full_time_year_round <int>,
## # unemployed <int>, unemployment_rate <dbl>, median <int>, p25th <int>,
## # p75th <int>, college_jobs <int>, non_college_jobs <int>,
## # low_wage_jobs <int>## # A tibble: 6 x 9
## rank major_code major major_category total men women share_women
## <int> <int> <chr> <chr> <int> <int> <int> <dbl>
## 1 1 2419 PETR… Engineering 2339 2057 282 0.121
## 2 2 2416 MINI… Engineering 756 679 77 0.102
## 3 3 2415 META… Engineering 856 725 131 0.153
## 4 4 2417 NAVA… Engineering 1258 1123 135 0.107
## 5 5 2418 NUCL… Engineering 2573 2200 373 0.145
## 6 6 2405 CHEM… Engineering 32260 21239 11021 0.342
## # … with 1 more variable: median <int>
| STEM Major Statistics | |||
|---|---|---|---|
| College Major | Median Salary | Percent Women Employed | Percent Men Employed |
| Engineering | |||
| BIOMEDICAL ENGINEERING | $60,000.00 | 44% | 56% |
| ARCHITECTURE | $40,000.00 | 45% | 55% |
| MINING AND MINERAL ENGINEERING | $75,000.00 | 10% | 90% |
| MECHANICAL ENGINEERING RELATED TECHNOLOGIES | $40,000.00 | 8% | 92% |
| Physical Sciences | |||
| NUCLEAR, INDUSTRIAL RADIOLOGY, AND BIOLOGICAL TECHNOLOGIES | $46,000.00 | 75% | 25% |
| OCEANOGRAPHY | $44,700.00 | 69% | 31% |
| PHYSICS | $45,000.00 | 28% | 72% |
| ATMOSPHERIC SCIENCES AND METEOROLOGY | $35,000.00 | 32% | 68% |
| Computers & Mathematics | |||
| MATHEMATICS | $45,000.00 | 45% | 55% |
| STATISTICS AND DECISION SCIENCE | $45,000.00 | 53% | 47% |
| MATHEMATICS AND COMPUTER SCIENCE | $42,000.00 | 18% | 82% |
| COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY | $37,500.00 | 18% | 82% |
| Biology & Life Science | |||
| PHARMACOLOGY | $45,000.00 | 71% | 29% |
| NEUROSCIENCE | $35,000.00 | 64% | 36% |
| GENETICS | $40,000.00 | 52% | 48% |
| BIOCHEMICAL SCIENCES | $37,400.00 | 52% | 48% |
| Health | |||
| MEDICAL ASSISTING SERVICES | $42,000.00 | 93% | 7% |
| COMMUNICATION DISORDERS SCIENCES AND SERVICES | $28,000.00 | 97% | 3% |
| PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTRATION | $40,000.00 | 63% | 37% |
| HEALTH AND MEDICAL PREPARATORY PROGRAMS | $33,500.00 | 57% | 43% |
| Data from fivethirtyeight | |||